Enabling a Table
The type of time support enabled in the Bentley environment depends on the Oracle settings specified when the tables are version enabled.
In Oracle, EnableVersioning version enables a table, creating the necessary structures to enable the table to support multiple versions of rows.
DBMS_WM.EnableVersioning
|
Parameter |
Description |
|---|---|
|
table_name |
A string containing the name of the table |
|
hist |
NONE, VIEW_W_OVERWRITE, VIEW_WO_OVERWRITE |
|
isTopology |
Boolean value (TRUE or FALSE) |
|
validTime |
Boolean value (TRUE or FALSE) |
|
undo_space |
String |
For example, versioning the table LandUse with the validTime option set to true:
-
Versioning and valid time enabling for LandUse:
EXECUTE DBMS_WM.EnableVersioning('LandUse','NONE',FALSE,TRUE); -
Versioning and history enabling for LandUse:
EXECUTE DBMS_WM.EnableVersioning('LandUse','VIEW_WO_OVERWRITE ',FALSE,FALSE);
Note: Currently Bentley does not support specifying both validTime and History. If a table is registered with both, only the validTime behavior applies.
Once the table is version enabled with either the valid time or history option, those features will be recognized as time or history enabled when running Bentley Geospatial Administrator to register them.